package com.chrudgames.juicedietrecipes;

import java.sql.Date;
import java.util.ArrayList;
import java.util.Calendar;
import java.util.List;

import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
 
public class DatabaseHandler extends SQLiteOpenHelper {
 
    // All Static variables
    // Database Version
    private static final int DATABASE_VERSION = 1;
 
    // Database Name
    private static final String DATABASE_NAME = "Recipes";
 
    // Contacts table name
    private static final String TABLE_INFO = "Info";
 
    // Contacts Table Columns names
    private static final String KEY_ID = "_id";
    private static final String KEY_NAME = "name";
    private static final String KEY_ING = "ing";
    private static final String KEY_DESC = "description";
    private static final String KEY_EING = "eing";
    private static final String KEY_NUT = "nutrition";
    private static final String KEY_FAV = "favorite";
 
     
    public DatabaseHandler(Context context) {
        super(context, DATABASE_NAME, null, DATABASE_VERSION);
    }
 
    // Creating Tables
    @Override
    public void onCreate(SQLiteDatabase db) {
   
    	   	     	
        String CREATE_INFO_TABLE = "CREATE TABLE " + TABLE_INFO + "("
        		+ KEY_ID + " STRING," + KEY_NAME + " TEXT,"
                + KEY_ING + " TEXT," + KEY_DESC + " TEXT,"
                + KEY_EING + " TEXT," + KEY_NUT + " TEXT,"
                + KEY_FAV + " STRING)";
        
        
        db.execSQL(CREATE_INFO_TABLE);
        
        
   

  
    }
 
    // Upgrading database
    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        // Drop older table if existed
        db.execSQL("DROP TABLE IF EXISTS " + TABLE_INFO);
     
        onCreate(db);
    }
 
 
    void runQuery(String ssql) {
        SQLiteDatabase db = this.getWritableDatabase();
        db.execSQL(ssql);
        db.close();
    }

    // Getting single contact
    Recipe getRecipe(String id) {
        SQLiteDatabase db = this.getReadableDatabase();
 
        Cursor cursor = db.query(TABLE_INFO, new String[] { KEY_ID, KEY_NAME, KEY_ING, KEY_DESC, KEY_EING, KEY_NUT, KEY_FAV }, KEY_ID + "=?",
                new String[] { id }, null, null, null, null);
        if (cursor != null)
            cursor.moveToFirst();
 
        Recipe recipe = new Recipe(cursor.getString(0), cursor.getString(1), cursor.getString(2) , cursor.getString(3), cursor.getString(4), cursor.getString(5), Boolean.parseBoolean(cursor.getString(6)));
        // return contact
        cursor.close();
        db.close();
        
        return recipe;
    }
 
    // Getting All Contacts
    public List<Recipe> getAllRecipes() {
        List<Recipe> recipeList = new ArrayList<Recipe>();
        // Select All Query
        String selectQuery = "SELECT  * FROM " + TABLE_INFO;
 
        SQLiteDatabase db = this.getWritableDatabase();
        Cursor cursor = db.rawQuery(selectQuery, null);
 
        // looping through all rows and adding to list
        if (cursor.moveToFirst()) {
            do {
                Recipe recipe = new Recipe();
                recipe.setID(cursor.getString(0));
                recipe.setName(cursor.getString(1));
                recipe.setIng(cursor.getString(2));
                recipe.setDescription(cursor.getString(3));
                recipe.setEing(cursor.getString(4));
                recipe.setNutrition(cursor.getString(5));
                recipe.setFavorite(Boolean.parseBoolean(cursor.getString(6)));
                // Adding recipe to list
                recipeList.add(recipe);
            } while (cursor.moveToNext());
        }
 
        cursor.close();
        db.close();
        // return contact list
        return recipeList;
    }
 
    public Cursor getRecipeCursor(String id) {

	   	
        // Select All Query
        String selectQuery = "SELECT * FROM " + TABLE_INFO + " where _id='" + id +"'";
        SQLiteDatabase db = this.getWritableDatabase();
 
        Cursor cursor = db.rawQuery(selectQuery, null);
        

        return cursor;
      

    }
    
    public Cursor getAllRecipesCursor() {
    	
      	
        // Select All Query
        String selectQuery = "SELECT * FROM " + TABLE_INFO + " order by favorite desc, name";
        
        SQLiteDatabase db = this.getWritableDatabase();   
        
 
        Cursor cursor = db.rawQuery(selectQuery, null);

        return cursor;
      

    }
    
public Cursor getSearchRecipesCursor(String strsearch) {
    	
      	
        // Select All Query
        String selectQuery = "SELECT * FROM " + TABLE_INFO + " where name like '%" + strsearch + "%' or description like '%" + strsearch + "%' or ing like '%" + strsearch + "%' order by favorite desc, name";
        
        SQLiteDatabase db = this.getWritableDatabase();   
        
 
        Cursor cursor = db.rawQuery(selectQuery, null);

        return cursor;
      

    }
   
    // Getting contacts Count
    public int getRecipesCount() {

    	int count;
    	
        String countQuery = "SELECT  * FROM " + TABLE_INFO;

        SQLiteDatabase db = this.getReadableDatabase();
  
        Cursor cursor = db.rawQuery(countQuery, null);
//      
        count = cursor.getCount();
        cursor.close();

        return count;
      
    }
 
    public Date getTodaysDate() {

    	Calendar c = Calendar.getInstance();
        
        int month = c.get(Calendar.MONTH) + 1;
        String sDate =  c.get(Calendar.YEAR) + "-" + month + "-" + c.get(Calendar.DAY_OF_MONTH);
               
        Date dDate = Date.valueOf(sDate);
        
        // return count
        return dDate;
    }
    
    public void reCreateDB() {
    	
    	
    	SQLiteDatabase db = this.getWritableDatabase();
    	
    	
    	 String CREATE_INFO_TABLE = "CREATE TABLE IF NOT EXISTS " + TABLE_INFO + "("
         		+ KEY_ID + " STRING," + KEY_NAME + " TEXT,"
                 + KEY_ING + " TEXT," + KEY_DESC + " TEXT,"
                 + KEY_EING + " TEXT," + KEY_NUT + " TEXT,"
                 + KEY_FAV + " STRING)";
         
         
         db.execSQL(CREATE_INFO_TABLE);
         
        // db.close();
          
         
         runQuery("INSERT INTO INFO " +
 				"SELECT '0' as _id, 'Cucumber Cooler' as name, 'Apple Carrot Celery Cucumber Lemon' as ing, " +
 				"'Beta-Carotene from the carrots will help improve your sight while the lemon will give you a refreshed feeling.' as description, " +
 				"'1 apple\n4 medium carrots\n1 stalk celery\n1/4 medium cucumber, peeled\n1/2 lemon' as eing, " +
 				"'  Calories\t199.8\n  Total Fat\t1.2 g\n     Saturated Fat\t0.2 g\n     Polyunsaturated Fat\t0.5 g\n     Monounsaturated Fat\t0.1 g\n  Cholesterol\t0.0 mg\n  Sodium\t204.4 mg\n  Potassium\t1,151.8 mg\n  Total Carbohydrate\t29.0 g\n     Dietary Fiber\t5.7 g\n     Sugars\t12.3 g\n  Protein\t3.2 g\n  Vitamin A\t590.7 %\n  Vitamin B-12\t0.0 %\n  Vitamin B-6\t23.8 %\n  Vitamin C\t62.5 %\n  Vitamin D\t0.0 %\n  Vitamin E\t8.8 %\n  Calcium\t11.5 %\n  Copper\t11.1 %\n  Folate\t17.9 %\n  Iron\t7.0 %\n  Magnesium\t12.0 %\n  Manganese\t24.5 %\n  Niacin\t13.4 %\n  Pantothenic Acid\t9.7 %\n  Phosphorus\t11.7 %\n  Riboflavin\t11.4 %\n  Selenium\t1.6 %\n  Thiamin\t15.0 %\n  Zinc\t5.3 %\n\n*Percent Daily Values are based on a 2,000 calorie diet. Your daily values may be higher or lower depending on your calorie needs.' as nutrition, 0 as favorite " +
 				"UNION SELECT '1','Berry Blast','Raspberry Strawberry Blueberry','These berries are loaded with antioxidants that help strengthen arteries and are strongly linked to cancer prevention.','2 cups of raspberries\n2 cups of strawberries\n2 cups of blueberries','  Calories\t319.3\n  Total Fat\t2.5 g\n     Saturated Fat\t0.0 g\n     Polyunsaturated Fat\t1.3 g\n     Monounsaturated Fat\t0.3 g\n  Cholesterol\t0.0 mg\n  Sodium\t20.2 mg\n  Potassium\t1,110.2 mg\n  Total Carbohydrate\t49.7 g\n     Dietary Fiber\t19.2 g\n     Sugars\t45.2 g\n  Protein\t5.9 g\n  Vitamin A\t13.7 %\n  Vitamin B-12\t0.0 %\n  Vitamin B-6\t20.7 %\n  Vitamin C\t437.4 %\n  Vitamin D\t0.0 %\n  Vitamin E\t22.0 %\n  Calcium\t11.2 %\n  Copper\t25.0 %\n  Folate\t33.3 %\n  Iron\t16.7 %\n  Magnesium\t21.9 %\n  Manganese\t207.0 %\n  Niacin\t19.5 %\n  Pantothenic Acid\t18.4 %\n  Phosphorus\t11.4 %\n  Riboflavin\t32.7 %\n  Selenium\t7.4 %\n  Thiamin\t18.0 %\n  Zinc\t12.2 %\n\n*Percent Daily Values are based on a 2,000 calorie diet. Your daily values may be higher or lower depending on your calorie needs.','0' " +
 				"UNION SELECT '2','Extra Energy','Cucumber Apple Lemon Kale Spinach Celery Fennel Ginger Lettuce','All the vegetables will give you a blast of energy while the ginger and lemon will leave you feeling refreshed.','1/2 cup of spinach\n1/2 cucumber\n1/2 cup of kale\n2 apples\n6 stalks of celery\n1/4 bulb of fennel\n1/2 head of romaine lettuce\n1 inch of ginger\n1/2 lemon','  Calories\t199.7\n  Total Fat\t2.0 g\n     Saturated Fat\t0.3 g\n     Polyunsaturated Fat\t0.6 g\n     Monounsaturated Fat\t0.1 g\n  Cholesterol\t0.0 mg\n  Sodium\t113.7 mg\n  Potassium\t1,446.9 mg\n  Total Carbohydrate\t42.9 g\n     Dietary Fiber\t8.5 g\n     Sugars\t3.2 g\n  Protein\t5.8 g\n  Vitamin A\t256.3 %\n  Vitamin B-12\t0.0 %\n  Vitamin B-6\t23.2 %\n  Vitamin C\t154.3 %\n  Vitamin D\t0.0 %\n  Vitamin E\t12.1 %\n  Calcium\t18.0 %\n  Copper\t22.7 %\n  Folate\t52.5 %\n  Iron\t19.0 %\n  Magnesium\t20.4 %\n  Manganese\t67.9 %\n  Niacin\t9.2 %\n  Pantothenic Acid\t9.0 %\n  Phosphorus\t15.5 %\n  Riboflavin\t16.1 %\n  Selenium\t4.1 %\n  Thiamin\t16.7 %\n  Zinc\t6.7 %\n\n*Percent Daily Values are based on a 2,000 calorie diet. Your daily values may be higher or lower depending on your calorie needs.','0' " + 
 				"UNION SELECT '3','Amazing Alkaline','Spinach Cucumber Celery Carrot Apple','Loads of chlorophyll from the cucumber skin helps build red blood cells. The cucumber also contains silica which is great for your skin.','3 stalks of celery\n1/2 cucumber skin on\n1 cup of spinach\n3 carrots\n1/2 apple','  Calories\t131.4\n  Total Fat\t1.2 g\n     Saturated Fat\t0.2 g\n     Polyunsaturated Fat\t0.5 g\n     Monounsaturated Fat\t0.1 g\n  Cholesterol\t0.0 mg\n  Sodium\t257.4 mg\n  Potassium\t1,393.5 mg\n  Total Carbohydrate\t19.7 g\n     Dietary Fiber\t5.9 g\n     Sugars\t8.4 g\n  Protein\t4.6 g\n  Vitamin A\t507.2 %\n  Vitamin B-12\t0.0 %\n  Vitamin B-6\t25.6 %\n  Vitamin C\t65.9 %\n  Vitamin D\t0.0 %\n  Vitamin E\t10.8 %\n  Calcium\t16.4 %\n  Copper\t12.0 %\n  Folate\t37.1 %\n  Iron\t13.1 %\n  Magnesium\t19.7 %\n  Manganese\t39.9 %\n  Niacin\t13.9 %\n  Pantothenic Acid\t10.5 %\n  Phosphorus\t14.4 %\n  Riboflavin\t15.3 %\n  Selenium\t2.5 %\n  Thiamin\t16.5 %\n  Zinc\t7.2 %\n\n*Percent Daily Values are based on a 2,000 calorie diet. Your daily values may be higher or lower depending on your calorie needs.','0' " + 
 				"UNION SELECT '4','Apple-Cucumber Zing','Apple Cucumber Ginger','Ginger has an anti-inflammatory ability which can help with joint pain related to arthritis.Ginger also contains gingerol which can help prevent oxidative damage to your joint cells.','1/2 cucumber peeled\n3 apples\n1 inch of ginger','  Calories\t264.7\n  Total Fat\t2.0 g\n     Saturated Fat\t0.4 g\n     Polyunsaturated Fat\t0.5 g\n     Monounsaturated Fat\t0.1 g\n  Cholesterol\t0.0 mg\n  Sodium\t8.3 mg\n  Potassium\t812.0 mg\n  Total Carbohydrate\t43.8 g\n     Dietary Fiber\t6.8 g\n     Sugars\t2.2 g\n  Protein\t2.3 g\n  Vitamin A\t5.8 %\n  Vitamin B-12\t0.0 %\n  Vitamin B-6\t16.3 %\n  Vitamin C\t48.7 %\n  Vitamin D\t0.0 %\n  Vitamin E\t7.6 %\n  Calcium\t5.1 %\n  Copper\t17.5 %\n  Folate\t7.9 %\n  Iron\t7.0 %\n  Magnesium\t13.4 %\n  Manganese\t18.5 %\n  Niacin\t3.6 %\n  Pantothenic Acid\t5.9 %\n  Phosphorus\t6.6 %\n  Riboflavin\t5.8 %\n  Selenium\t2.4 %\n  Thiamin\t7.6 %\n  Zinc\t3.3 %\n\n*Percent Daily Values are based on a 2,000 calorie diet. Your daily values may be higher or lower depending on your calorie needs.','0' " + 
 				"UNION SELECT '5','Heartburn Helper','Spinach Kale Cucumber Parsley Apple','This juice will help tame your heartburn. The apple helps to make the juice a little sweeter.','1 cup of spinach\n1/2 cucumber\n1 cup of kale\n1 cup of parsley\n1 apple','  Calories\t138.4\n  Total Fat\t1.8 g\n     Saturated Fat\t0.3 g\n     Polyunsaturated Fat\t0.5 g\n     Monounsaturated Fat\t0.2 g\n  Cholesterol\t0.0 mg\n  Sodium\t89.2 mg\n  Potassium\t1,091.6 mg\n  Total Carbohydrate\t18.4 g\n     Dietary Fiber\t4.7 g\n     Sugars\t3.6 g\n  Protein\t6.0 g\n  Vitamin A\t514.4 %\n  Vitamin B-12\t0.0 %\n  Vitamin B-6\t20.5 %\n  Vitamin C\t254.4 %\n  Vitamin D\t0.0 %\n  Vitamin E\t16.3 %\n  Calcium\t23.0 %\n  Copper\t23.0 %\n  Folate\t46.1 %\n  Iron\t34.3 %\n  Magnesium\t24.0 %\n  Manganese\t52.1 %\n  Niacin\t9.0 %\n  Pantothenic Acid\t6.5 %\n  Phosphorus\t11.7 %\n  Riboflavin\t14.8 %\n  Selenium\t2.9 %\n  Thiamin\t13.2 %\n  Zinc\t8.9 %\n\n*Percent Daily Values are based on a 2,000 calorie diet. Your daily values may be higher or lower depending on your calorie needs.','0' " + 
 				"UNION SELECT '6','Beautiful Beet','Apple Carrot Beet Ginger','The color of this juice is absolutely wonderful and it is packed with flavor.','1 apple\n3 carrots\n2 beets\n1 inch of ginger','  Calories\t235.4\n  Total Fat\t1.6 g\n     Saturated Fat\t0.3 g\n     Polyunsaturated Fat\t0.5 g\n     Monounsaturated Fat\t0.2 g\n  Cholesterol\t0.0 mg\n  Sodium\t260.4 mg\n  Potassium\t1,476.5 mg\n  Total Carbohydrate\t42.8 g\n     Dietary Fiber\t7.4 g\n     Sugars\t20.2 g\n  Protein\t5.5 g\n  Vitamin A\t443.1 %\n  Vitamin B-12\t0.0 %\n  Vitamin B-6\t25.3 %\n  Vitamin C\t48.5 %\n  Vitamin D\t0.0 %\n  Vitamin E\t9.5 %\n  Calcium\t10.4 %\n  Copper\t18.5 %\n  Folate\t55.7 %\n  Iron\t13.3 %\n  Magnesium\t21.8 %\n  Manganese\t48.7 %\n  Niacin\t14.1 %\n  Pantothenic Acid\t9.4 %\n  Phosphorus\t15.6 %\n  Riboflavin\t12.2 %\n  Selenium\t3.0 %\n  Thiamin\t13.8 %\n  Zinc\t8.2 %\n\n*Percent Daily Values are based on a 2,000 calorie diet. Your daily values may be higher or lower depending on your calorie needs.','0' " + 
 				"UNION SELECT '7','Craving Curber','Orange Strawberry Apple Raspberry','All the fruit gives a very sweet flavor that reduces your cravings for unhealthy sweets.','1 and a 1/2 cups of raspberries\n1 cup of strawberries\n2 oranges\n2 apples','  Calories\t389.6\n  Total Fat\t2.9 g\n     Saturated Fat\t0.2 g\n     Polyunsaturated Fat\t1.2 g\n     Monounsaturated Fat\t0.2 g\n  Cholesterol\t0.0 mg\n  Sodium\t1.4 mg\n  Potassium\t1,311.1 mg\n  Total Carbohydrate\t84.4 g\n     Dietary Fiber\t19.6 g\n     Sugars\t32.3 g\n  Protein\t5.5 g\n  Vitamin A\t19.3 %\n  Vitamin B-12\t0.0 %\n  Vitamin B-6\t24.0 %\n  Vitamin C\t471.4 %\n  Vitamin D\t0.0 %\n  Vitamin E\t12.6 %\n  Calcium\t18.5 %\n  Copper\t22.0 %\n  Folate\t40.2 %\n  Iron\t13.1 %\n  Magnesium\t21.9 %\n  Manganese\t123.9 %\n  Niacin\t14.6 %\n  Pantothenic Acid\t17.6 %\n  Phosphorus\t10.5 %\n  Riboflavin\t23.8 %\n  Selenium\t6.1 %\n  Thiamin\t23.9 %\n  Zinc\t8.8 %\n\n*Percent Daily Values are based on a 2,000 calorie diet. Your daily values may be higher or lower depending on your calorie needs.','0' " + 
 				"UNION SELECT '8','Headache Halter','Cauliflower Broccoli Apple','Cauliflower and broccoli are rich in calcium and magnesium which are essential for relieving headaches.Vitamin C from the apples will help detoxify your system.','1 cup of cauliflower\n1 cup of broccoli\n2 apples','  Calories\t192.5\n  Total Fat\t1.5 g\n     Saturated Fat\t0.2 g\n     Polyunsaturated Fat\t0.5 g\n     Monounsaturated Fat\t0.1 g\n  Cholesterol\t0.0 mg\n  Sodium\t53.8 mg\n  Potassium\t906.4 mg\n  Total Carbohydrate\t41.9 g\n     Dietary Fiber\t6.6 g\n     Sugars\t0.0 g\n  Protein\t5.1 g\n  Vitamin A\t30.4 %\n  Vitamin B-12\t0.0 %\n  Vitamin B-6\t24.7 %\n  Vitamin C\t240.2 %\n  Vitamin D\t0.0 %\n  Vitamin E\t11.9 %\n  Calcium\t8.4 %\n  Copper\t9.7 %\n  Folate\t31.9 %\n  Iron\t9.5 %\n  Magnesium\t12.7 %\n  Manganese\t24.1 %\n  Niacin\t6.5 %\n  Pantothenic Acid\t12.9 %\n  Phosphorus\t12.1 %\n  Riboflavin\t12.1 %\n  Selenium\t5.8 %\n  Thiamin\t10.7 %\n  Zinc\t4.9 %\n\n*Percent Daily Values are based on a 2,000 calorie diet. Your daily values may be higher or lower depending on your calorie needs.','0' " + 
 				"UNION SELECT '9','Incredible Immune','Carrot Apple Celery Garlic Parsley','The vitamins and minerals from this juice will give your immune system a boost.','4-6 carrots\n3 stalks of celery\n2-3 cloves of garlic\n1 apple\n1 cup of parsley','  Calories\t228.4\n  Total Fat\t1.9 g\n     Saturated Fat\t0.3 g\n     Polyunsaturated Fat\t0.7 g\n     Monounsaturated Fat\t0.3 g\n  Cholesterol\t0.0 mg\n  Sodium\t349.7 mg\n  Potassium\t1,841.6 mg\n  Total Carbohydrate\t50.9 g\n     Dietary Fiber\t8.4 g\n     Sugars\t14.4 g\n  Protein\t6.3 g\n  Vitamin A\t840.0 %\n  Vitamin B-12\t0.0 %\n  Vitamin B-6\t36.9 %\n  Vitamin C\t194.0 %\n  Vitamin D\t0.0 %\n  Vitamin E\t16.7 %\n  Calcium\t25.5 %\n  Copper\t17.3 %\n  Folate\t46.8 %\n  Iron\t30.5 %\n  Magnesium\t22.1 %\n  Manganese\t42.1 %\n  Niacin\t21.7 %\n  Pantothenic Acid\t14.2 %\n  Phosphorus\t19.3 %\n  Riboflavin\t18.7 %\n  Selenium\t4.2 %\n  Thiamin\t23.1 %\n  Zinc\t11.1 %\n\n*Percent Daily Values are based on a 2,000 calorie diet. Your daily values may be higher or lower depending on your calorie needs.','0' " + 
 				"UNION SELECT '10','V-8 Vibe','Tomato Garlic Spinach Carrot Onion Celery Lemon Water Hot Sauce','A mock V-8 juice that will supply you with those wonderful veggies','1 tomato \n1 handful of spinach\n2 carrots\n2 cloves of garlic\n1/4 sweet onion\n2 celery stalks\n1/2 cup of spring water\n2 tsp. of lemon juice\n1-2 shots of hot sauce','  Calories\t87.2\n  Total Fat\t0.8 g\n     Saturated Fat\t0.1 g\n     Polyunsaturated Fat\t0.4 g\n     Monounsaturated Fat\t0.1 g\n  Cholesterol\t0.0 mg\n  Sodium\t328.7 mg\n  Potassium\t960.4 mg\n  Total Carbohydrate\t19.5 g\n     Dietary Fiber\t3.4 g\n     Sugars\t7.2 g\n  Protein\t3.8 g\n  Vitamin A\t360.0 %\n  Vitamin B-12\t0.0 %\n  Vitamin B-6\t23.5 %\n  Vitamin C\t90.0 %\n  Vitamin D\t0.0 %\n  Vitamin E\t7.5 %\n  Calcium\t12.5 %\n  Copper\t9.5 %\n  Folate\t29.3 %\n  Iron\t10.8 %\n  Magnesium\t14.5 %\n  Manganese\t34.7 %\n  Niacin\t9.3 %\n  Pantothenic Acid\t6.5 %\n  Phosphorus\t10.5 %\n  Riboflavin\t11.8 %\n  Selenium\t3.2 %\n  Thiamin\t12.7 %\n  Zinc\t5.0 %\n\n*Percent Daily Values are based on a 2,000 calorie diet. Your daily values may be higher or lower depending on your calorie needs.','0' " + 
 				"UNION SELECT '11','Bone Builder','Broccoli Carrot Apple Parsley Lemon','A drink to help strengthen those bones.','1 apple\n3 carrots\n1/2 cup of broccoli\n1/4 cup of parsely\n1/2 lemon','  Calories\t146.4\n  Total Fat\t1.1 g\n     Saturated Fat\t0.2 g\n     Polyunsaturated Fat\t0.4 g\n     Monounsaturated Fat\t0.1 g\n  Cholesterol\t0.0 mg\n  Sodium\t141.2 mg\n  Potassium\t944.1 mg\n  Total Carbohydrate\t35.2 g\n     Dietary Fiber\t5.4 g\n     Sugars\t8.9 g\n  Protein\t3.5 g\n  Vitamin A\t464.1 %\n  Vitamin B-12\t0.0 %\n  Vitamin B-6\t20.3 %\n  Vitamin C\t128.6 %\n  Vitamin D\t0.0 %\n  Vitamin E\t10.6 %\n  Calcium\t10.0 %\n  Copper\t8.6 %\n  Folate\t20.2 %\n  Iron\t8.3 %\n  Magnesium\t10.9 %\n  Manganese\t21.7 %\n  Niacin\t11.4 %\n  Pantothenic Aci\td8.6 %\n  Phosphorus\t10.7 %\n  Riboflavin\t10.9 %\n  Selenium\t2.8 %\n  Thiamin\t12.3 %\n  Zinc\t4.9 %\n\n*Percent Daily Values are based on a 2,000 calorie diet. Your daily values may be higher or lower depending on your calorie needs.','0' " + 
 				"UNION SELECT '12','Protective Potassium','Carrot Celery Apple Parsley Spinach Lemon','Provides plenty of potassium to keep your heart, kidneys, muscles, nerves, and digestive system working properly.','2 stalks of celery\n1 apple\n4 carrots\n1/2 cups of fresh parsley\n1/2 cups of fresh spinach\n1/2 lemon','  Calories\t188.8\n  Total Fat\t1.4 g\n     Saturated Fat\t0.2 g\n     Polyunsaturated Fat\t0.5 g\n     Monounsaturated Fat\t0.1 g\n  Cholesterol\t0.0 mg\n  Sodium\t264.7 mg\n  Potassium\t1,393.3 mg\n  Total Carbohydrate\t40.8 g\n     Dietary Fiber\t6.8 g\n     Sugars\t11.8 g\n  Protein\t4.2 g\n  Vitamin A\t655.7 %\n  Vitamin B-12\t0.0 %\n  Vitamin B-6\t27.4 %\n  Vitamin C\t89.6 %\n  Vitamin D\t0.0 %\n  Vitamin E\t12.6 %\n  Calcium\t16.0 %\n  Copper\t12.3 %\n  Folate\t35.4 %\n  Iron\t13.5 %\n  Magnesium\t18.1 %\n  Manganese\t38.6 %\n  Niacin\t15.3 %\n  Pantothenic Acid\t9.6 %\n  Phosphorus\t13.4 %\n  Riboflavin\t15.3 %\n  Selenium\t2.4 %\n  Thiamin\t17.1 %\n  Zinc\t6.5 %\n\n*Percent Daily Values are based on a 2,000 calorie diet. Your daily values may be higher or lower depending on your calorie needs.','0' " + 
 				"UNION SELECT '13','Brain Booster','Orange Pear Yam Grapefruit Apple','Gives your brain a boost for better memory and sharper thinking.','2 hard pears\n1 yam\n1 grapefruit\n1 orange\n1 apple','  Calories\t480.4\n  Total Fat\t2.4 g\n     Saturated Fat\t0.2 g\n     Polyunsaturated Fat\t0.6 g\n     Monounsaturated Fat\t0.3 g\n  Cholesterol\t0.0 mg\n  Sodium\t10.9 mg\n  Potassium\t2,034.4 mg\n  Total Carbohydrate\t122.6 g\n     Dietary Fiber\t11.8 g\n     Sugars\t13.0 g\n  Protein\t6.2 g\n  Vitamin A\t24.2 %\n  Vitamin B-12\t0.0 %\n  Vitamin B-6\t30.9 %\n  Vitamin C\t330.5 %\n  Vitamin D\t0.0 %\n  Vitamin E\t16.1 %\n  Calcium\t15.5 %\n  Copper\t40.3 %\n  Folate\t27.6 %\n  Iron\t12.3 %\n  Magnesium\t21.0 %\n  Manganese\t43.9 %\n  Niacin\t10.2 %\n  Pantothenic Acid\t17.6 %\n  Phosphorus\t15.3 %\n  Riboflavin\t17.2 %\n  Selenium\t12.6 %\n  Thiamin\t28.8 %\n  Zinc\t6.6 %\n\n*Percent Daily Values are based on a 2,000 calorie diet. Your daily values may be higher or lower depending on your calorie needs.','0' " + 
 				"UNION SELECT '14','Pain Pusher','Pear Apple Orange Lemon','Helps to relieve the pain of bruises and sprains.','3 hard pears\n3 apples\n1 orange\n1/2 lemon','  Calories\t575.5\n  Total Fat\t3.6 g\n     Saturated Fat\t0.3 g\n     Polyunsaturated Fat\t0.9 g\n     Monounsaturated Fat\t0.5 g\n  Cholesterol\t0.0 mg\n  Sodium\t0.2 mg\n  Potassium\t1,364.9 mg\n  Total Carbohydrate\t125.8 g\n     Dietary Fiber\t12.4 g\n     Sugars\t12.9 g\n  Protein\t4.1 g\n  Vitamin A\t11.9 %\n  Vitamin B-12\t0.0 %\n  Vitamin B-6\t18.9 %\n  Vitamin C\t206.7 %\n  Vitamin D\t0.0 %\n  Vitamin E\t20.6 %\n  Calcium\t13.8 %\n  Copper\t40.0 %\n  Folate\t22.4 %\n  Iron\t11.8 %\n  Magnesium\t16.3 %\n  Manganese\t30.0 %\n  Niacin\t6.0 %\n  Pantothenic Acid\t9.5 %\n  Phosphorus\t10.3 %\n  Riboflavin\t18.3 %\n  Selenium\t9.9 %\n  Thiamin\t19.4 %\n  Zinc\t5.8\n\n*Percent Daily Values are based on a 2,000 calorie diet. Your daily values may be higher or lower depending on your calorie needs.','0' " + 
 				"UNION SELECT '15','Superb Sight','Fennel Beet Apple','The fennel increases eye sensitivity helping to overcome night blindness. Fennel is also said to help relieve migraines.','1 fennel bulb\n1 beet\n2 apples','  Calories\t240.6\n  Total Fat\t1.6 g\n     Saturated Fat\t0.2 g\n     Polyunsaturated Fat\t0.3 g\n     Monounsaturated Fat\t0.1 g\n  Cholesterol\t0.0 mg\n  Sodium\t185.6 mg\n  Potassium\t1,552.7 mg\n  Total Carbohydrate\t57.0 g\n     Dietary Fiber\t7.0 g\n     Sugars\t5.5 g\n  Protein\t4.7 g\n  Vitamin A\t9.7 %\n  Vitamin B-12\t0.0 %\n  Vitamin B-6\t14.9 %\n  Vitamin C\t79.7 %\n  Vitamin D\t0.0 %\n  Vitamin E\t5.6 %\n  Calcium\t14.7 %\n  Copper\t16.5 %\n  Folate\t40.2 %\n  Iron\t15.9 %\n  Magnesium\t18.1 %\n  Manganese\t42.0 %\n  Niacin\t9.9 %\n  Pantothenic Acid\t8.4 %\n  Phosphorus\t16.9 %\n  Riboflavin\t8.6 %\n  Selenium\t4.3 %\n  Thiamin\t6.4 %\n  Zinc\t5.8 %\n\n*Percent Daily Values are based on a 2,000 calorie diet. Your daily values may be higher or lower depending on your calorie needs.','0' " + 
 				"UNION SELECT '16','Rich Roots','Beet Carrot Celery Potato Radish','This juice has been used in natural cancer treatments.','1 potato\n1 carrot\n1 radish\n1 celery stalk\n1 beet','  Calories\t201.4\n  Total Fat\t0.5 g\n     Saturated Fat\t0.1 g\n     Polyunsaturated Fat\t0.2 g\n     Monounsaturated Fat\t0.1 g\n  Cholesterol\t0.0 mg\n  Sodium\t155.4 mg\n  Potassium\t1,483.7 mg\n  Total Carbohydrate\t42.5 g\n     Dietary Fiber\t5.4 g\n     Sugars\t10.1 g\n  Protein\t6.5 g\n  Vitamin A\t148.5 %\n  Vitamin B-12\t0.0 %\n  Vitamin B-6\t40.3 %\n  Vitamin C\t88.4 %\n  Vitamin D\t0.0 %\n  Vitamin E\t3.6 %\n  Calcium\t7.6 %\n  Copper\t16.7 %\n  Folate\t36.8 %\n  Iron\t14.9 %\n  Magnesium\t20.0 %\n  Manganese\t36.3 %\n  Niacin\t16.3 %\n  Pantothenic Acid\t10.1 %\n  Phosphorus\t18.6 %\n  Riboflavin\t9.2 %\n  Selenium\t2.4 %\n  Thiamin\t17.0 %\n  Zinc\t7.4 %\n\n*Percent Daily Values are based on a 2,000 calorie diet. Your daily values may be higher or lower depending on your calorie needs.','0' " + 
 				"UNION SELECT '17','Better Bladder','Cranberry Apple','These ingredients will help clear the toxins out of your bladder.','1 and a 1/2 cups of cranberries\n2 apples','Calories\t208.4\n  Total Fat\t1.2 g\n     Saturated Fat\t0.2 g\n     Polyunsaturated Fat\t0.4 g\n     Monounsaturated Fat\t0.1 g\n  Cholesterol\t0.0 mg\n  Sodium\t2.9 mg\n  Potassium\t438.5 mg\n  Total Carbohydrate\t49.5 g\n     Dietary Fiber\t7.0 g\n     Sugars\t5.8 g\n  Protein\t1.1 g\n  Vitamin A\t4.6 %\n  Vitamin B-12\t0.0 %\n  Vitamin B-6\t10.7 %\n  Vitamin C\t57.8 %\n  Vitamin D\t0.0 %\n  Vitamin E\t5.1 %\n  Calcium\t3.1 %\n  Copper\t10.0 %\n  Folate\t2.4 %\n  Iron\t4.7 %\n  Magnesium\t5.6 %\n  Manganese\t31.9 %\n  Niacin\t1.8 %\n  Pantothenic Acid\t5.9 %\n  Phosphorus\t3.8 %\n  Riboflavin\t3.9 %\n  Selenium\t1.4 %\n  Thiamin\t4.3 %\n  Zinc\t1.7 %\n\n*Percent Daily Values are based on a 2,000 calorie diet. Your daily values may be higher or lower depending on your calorie needs.','0' " + 
 				"UNION SELECT '18','Beneficial Beetroot','Beetroot Cucumber Pineapple','Helps to cleanse your body. Best consumed on an empty stomach.','1/2 cucumber\n1 and a 1/2 cups of pineapple chunks\n1 small beetroot', '  Calories\t195.1\n  Total Fat\t1.4 g\n     Saturated Fat\t0.0 g\n     Polyunsaturated Fat\t0.3 g\n     Monounsaturated Fat\t0.2 g\n  Cholesterol\t0.0 mg\n  Sodium\t4.4 mg\n  Potassium\t399.5 mg\n  Total Carbohydrate\t21.0 g\n     Dietary Fiber\t1.6 g\n     Sugars\t39.4 g\n  Protein\t1.5 g\n  Vitamin A\t2.5 %\n  Vitamin B-12\t0.0 %\n  Vitamin B-6\t12.6 %\n  Vitamin C\t65.1 %\n  Vitamin D\t0.0 %\n  Vitamin E\t1.6 %\n  Calcium\t3.1 %\n  Copper\t16.4 %\n  Folate\t10.0 %\n  Iron\t6.0 %\n  Magnesium\t11.1 %\n  Manganese\t195.4 %\n  Niacin\t5.1 %\n  Pantothenic Acid\t6.2 %\n  Phosphorus\t3.8 %\n  Riboflavin\t6.4 %\n  Selenium\t2.1 %\n  Thiamin\t16.3 %\n  Zinc\t2.3 %\n\n*Percent Daily Values are based on a 2,000 calorie diet. Your daily values may be higher or lower depending on your calorie needs.','0' " + 
 				"UNION SELECT '19','Fabulous Fruit','Apple Cranberry Grape','A drink full of fruit to keep you healthy.','2 apples\n1 cup of cranberries\n1 cup of grapes','  Calories\t246.5\n  Total Fat\t2.0 g\n     Saturated Fat\t0.5 g\n     Polyunsaturated Fat\t0.6 g\n     Monounsaturated Fat\t0.1 g\n  Cholesterol\t0.0 mg\n  Sodium\t5.1 mg\n  Potassium\t574.2 mg\n  Total Carbohydrate\t72.1 g\n     Dietary Fiber\t7.4 g\n     Sugars\t18.8 g\n  Protein\t2.0 g\n  Vitamin A\t6.4 %\n  Vitamin B-12\t0.0 %\n  Vitamin B-6\t18.1 %\n  Vitamin C\t76.1 %\n  Vitamin D\t0.0 %\n  Vitamin E\t10.5 %\n  Calcium\t4.5 %\n  Copper\t15.8 %\n  Folate\t3.9 %\n  Iron\t6.4 %\n  Magnesium\t7.3 %\n  Manganese\t28.0 %\n  Niacin\t3.9 %\n  Pantothenic Acid\t4.9 %\n  Phosphorus\t5.3 %\n  Riboflavin\t8.8 %\n  Selenium\t1.8 %\n  Thiamin\t13.7 %\n  Zinc\t1.9 %\n\n*Percent Daily Values are based on a 2,000 calorie diet. Your daily values may be higher or lower depending on your calorie needs.','0' " + 
 				"UNION SELECT '20','Colon Cleaner','Apple Carrot Cucumber Celery Honey Lemon Water','The ingredients in this drink will help cleanse your colon.','7 slices of cucumber\n1 red apple\n1 stalk of celery\n1 carrot\n1 tbsp. of honey\n1 lemon\n2 cups of water','  Calories\t174.3\n  Total Fat\t0.8 g\n     Saturated Fat\t0.1 g\n     Polyunsaturated Fat\t0.2 g\n     Monounsaturated Fat\t0.0 g\n  Cholesterol\t0.0 mg\n  Sodium\t79.2 mg\n  Potassium\t604.5 mg\n  Total Carbohydrate\t40.8 g\n     Dietary Fiber\t3.7 g\n     Sugars\t21.8 g\n  Protein\t1.7 g\n  Vitamin A\t150.3 %\n  Vitamin B-12\t0.0 %\n  Vitamin B-6\t12.0 %\n  Vitamin C\t62.6 %\n  Vitamin D\t0.0 %\n  Vitamin E\t4.7 %\n  Calcium\t5.7 %\n  Copper\t7.7 %\n  Folate\t10.1 %\n  Iron\t4.5 %\n  Magnesium\t6.9 %\n  Manganese\t12.3 %\n  Niacin\t4.6 %\n  Pantothenic Acid\t5.1 %\n  Phosphorus\t5.5 %\n  Riboflavin\t5.7 %\n  Selenium\t1.6 %\n  Thiamin\t7.4 %\n  Zinc\t2.7 %\n\n*Percent Daily Values are based on a 2,000 calorie diet. Your daily values may be higher or lower depending on your calorie needs.','0' " + 
 				"UNION SELECT '21','Fabled Fruit','Apple Orange Lemon Blueberry Strawberry','The fantastic taste of this drink will leave you wanting more. Good if you don''t eat enough fruit. Goes good as a smoothie.','2 apples\n2 oranges\n1 lemon\n1 cup of blueberries\n2 cups of strawberries','  Calories\t341.5\n  Total Fat\t1.9 g\n     Saturated Fat\t0.2 g\n     Polyunsaturated Fat\t0.6 g\n     Monounsaturated Fat\t0.1 g\n  Cholesterol\t0.0 mg\n  Sodium\t6.2 mg\n  Potassium\t1,153.5 mg\n  Total Carbohydrate\t77.4 g\n     Dietary Fiber\t9.2 g\n     Sugars\t41.0 g\n  Protein\t4.5 g\n  Vitamin A\t16.1 %\n  Vitamin B-12\t0.0 %\n  Vitamin B-6\t21.2 %\n  Vitamin C\t446.3 %\n  Vitamin D\t0.0 %\n  Vitamin E\t12.3 %\n  Calcium\t15.2 %\n  Copper\t18.1 %\n  Folate\t30.8 %\n  Iron\t8.0 %\n  Magnesium\t15.2 %\n  Manganese\t40.8 %\n  Niacin\t7.9 %\n  Pantothenic Acid\t14.3 %\n  Phosphorus\t9.4 %\n  Riboflavin\t16.4 %\n  Selenium\t5.2 %\n  Thiamin\t23.5 %\n  Zinc\t3.8 %\n\n*Percent Daily Values are based on a 2,000 calorie diet. Your daily values may be higher or lower depending on your calorie needs.','0' " + 
 				"UNION SELECT '22','Savory Skin', 'Apple Cinnamon','Will give you more energy, provide some detox benefits, and help your skin look great.','4 apples\nA pinch of cinnamon','Calories\t301.7\n  Total Fat\t2.1 g\n     Saturated Fat\t0.3 g\n     Polyunsaturated Fat\t0.6 g\n     Monounsaturated Fat\t0.1 g\n  Cholesterol\t0.0 mg\n  Sodium\t0.6 mg\n  Potassium\t646.3 mg\n  Total Carbohydrate\t76.0 g\n     Dietary Fiber\t8.2 g\n     Sugars\t0.0 g\n  Protein\t1.1 g\n  Vitamin A\t6.0 %\n  Vitamin B-12\t0.0 %\n  Vitamin B-6\t13.6 %\n  Vitamin C\t53.5 %\n  Vitamin D\t0.0 %\n  Vitamin E\t8.8 %\n  Calcium\t6.7 %\n  Copper\t11.6 %\n  Folate\t4.3 %\n  Iron\t10.4 %\n  Magnesium\t7.2 %\n  Manganese\t31.6 %\n  Niacin\t2.3 %\n  Pantothenic Acid\t3.4 %\n  Phosphorus\t4.0 %\n  Riboflavin\t4.7 %\n  Selenium\t2.4 %\n  Thiamin\t6.4 %\n  Zinc\t1.8 %\n\n*Percent Daily Values are based on a 2,000 calorie diet. Your daily values may be higher or lower depending on your calorie needs.','0' " + 
 				"UNION SELECT '23','Immovable Immune', 'Pear Cranberry','Will give your immune system a huge boost, improve your energy, and improve your skin.','3 pears\n1 cup of cranberries','  Calories\t307.5\n  Total Fat\t2.1 g\n     Saturated Fat\t0.1 g\n     Polyunsaturated Fat\t0.5 g\n     Monounsaturated Fat\t0.4 g\n  Cholesterol\t0.0 mg\n  Sodium\t1.9 mg\n  Potassium\t703.3 mg\n  Total Carbohydrate\t76.8 g\n     Dietary Fiber\t8.3 g\n     Sugars\t3.8 g\n  Protein\t2.3 g\n  Vitamin A\t3.1 %\n  Vitamin B-12\t0.0 %\n  Vitamin B-6\t7.2 %\n  Vitamin C\t54.3 %\n  Vitamin D\t0.0 %\n  Vitamin E\t12.9 %\n  Calcium\t6.2 %\n  Copper\t31.0 %\n  Folate\t9.0 %\n  Iron\t8.2 %\n  Magnesium\t8.9 %\n  Manganese\t36.0 %\n  Niacin\t3.0 %\n  Pantothenic Acid\t6.3 %\n  Phosphorus\t6.7 %\n  Riboflavin\t12.8 %\n  Selenium\t7.3 %\n  Thiamin\t7.4 %\n  Zinc\t4.6 %\n\n*Percent Daily Values are based on a 2,000 calorie diet. Your daily values may be higher or lower depending on your calorie needs.','0' " + 
 				"UNION SELECT '24','Noble Nutrition', 'Grapefruit Blackberry Blueberry','This drink is packed to the brim with nutrition.','2 grapefruits\n1 cup of blackberries\n1 and a 1/2 cups of blueberries','  Calories\t314.3\n  Total Fat\t1.1 g\n     Saturated Fat\t0.1 g\n     Polyunsaturated Fat\t0.4 g\n     Monounsaturated Fat\t0.1 g\n  Cholesterol\t0.0 mg\n  Sodium\t13.1 mg\n  Potassium\t1,100.7 mg\n  Total Carbohydrate\t76.0 g\n     Dietary Fiber\t9.9 g\n     Sugars\t22.5 g\n  Protein\t5.2 g\n  Vitamin A\t34.6 %\n  Vitamin B-12\t0.0 %\n  Vitamin B-6\t18.4 %\n  Vitamin C\t400.9 %\n  Vitamin D\t0.0 %\n  Vitamin E\t22.0 %\n  Calcium\t13.3 %\n  Copper\t27.5 %\n  Folate\t26.6 %\n  Iron\t9.9 %\n  Magnesium\t19.7 %\n  Manganese\t126.0 %\n  Niacin\t11.7 %\n  Pantothenic Acid\t19.3 %\n  Phosphorus\t9.7 %\n  Riboflavin\t15.6 %\n  Selenium\t12.9 %\n  Thiamin\t23.0 %\n  Zinc\t6.5 %\n\n*Percent Daily Values are based on a 2,000 calorie diet. Your daily values may be higher or lower depending on your calorie needs.','0' " + 
 				"UNION SELECT '25','Prostate Protecter', 'Cabbage Watermelon Honey','The lycopene in this drink will help prevent prostate cancer and heart disease.','50g of cabbage \n2 slices of watermelon\n1 teaspoon of honey','  Calories\t207.7\n  Total Fat\t2.8 g\n     Saturated Fat\t0.4 g\n     Polyunsaturated Fat\t0.8 g\n     Monounsaturated Fat\t0.8 g\n  Cholesterol\t0.0 mg\n  Sodium\t21.1 mg\n  Potassium\t791.9 mg\n  Total Carbohydrate\t42.8 g\n     Dietary Fiber\t2.2 g\n     Sugars\t46.3 g\n  Protein\t4.5 g\n  Vitamin A\t43.5 %\n  Vitamin B-12\t0.0 %\n  Vitamin B-6\t43.4 %\n  Vitamin C\t118.4 %\n  Vitamin D\t0.0 %\n  Vitamin E\t4.4 %\n  Calcium\t6.9 %\n  Copper\t9.9 %\n  Folate\t8.4 %\n  Iron\t7.5 %\n  Magnesium\t17.4 %\n  Manganese\t14.7 %\n  Niacin\t6.4 %\n  Pantothenic Acid\t13.2 %\n  Phosphorus\t6.5 %\n  Riboflavin\t8.1 %\n  Selenium\t1.5 %\n  Thiamin\t32.2 %\n  Zinc\t3.4 %\n\n*Percent Daily Values are based on a 2,000 calorie diet. Your daily values may be higher or lower depending on your calorie needs.','0' " + 
 				"UNION SELECT '26','Eagle Eye', 'Melon Mango Milk','Vitamin A from the mango will boost your eye sight and is also believed to relieve eye tiredness.','2 slices of honeydew melon \n1 cup of mango flesh \n3/4 cups of milk','  Calories\t193.1\n  Total Fat\t0.9 g\n     Saturated Fat\t0.3 g\n     Polyunsaturated Fat\t0.2 g\n     Monounsaturated Fat\t0.2 g\n  Cholesterol\t2.5 mg\n  Sodium\t123.3 mg\n  Potassium\t1,089.0 mg\n  Total Carbohydrate\t42.0 g\n     Dietary Fiber\t2.4 g\n     Sugars\t40.8 g\n  Protein\t6.4 g\n  Vitamin A\t23.5 %\n  Vitamin B-12\t7.8 %\n  Vitamin B-6\t23.2 %\n  Vitamin C\t144.2 %\n  Vitamin D\t12.5 %\n  Vitamin E\t8.2 %\n  Calcium\t18.0 %\n  Copper\t10.0 %\n  Folate\t20.2 %\n  Iron\t4.0 %\n  Magnesium\t13.6 %\n  Manganese\t5.8 %\n  Niacin\t10.2 %\n  Pantothenic Acid\t10.6 %\n  Phosphorus\t17.0 %\n  Riboflavin\t15.7 %\n  Selenium\t7.8 %\n  Thiamin\t14.9 %\n  Zinc\t5.4 %\n\n*Percent Daily Values are based on a 2,000 calorie diet. Your daily values may be higher or lower depending on your calorie needs.','0' " + 
 				"UNION SELECT '27','Heat Hollower', 'Orange Mango Yogurt','Mango and orange juice are believed to reduce the risk of heat stroke. A great drink for the summer.','1/2 cups of mango flesh \n1 orange \n3/4 cups of yogurt','  Calories\t242.1\n  Total Fat\t3.6 g\n     Saturated Fat\t2.1 g\n     Polyunsaturated Fat\t0.2 g\n     Monounsaturated Fat\t1.0 g\n  Cholesterol\t12.0 mg\n  Sodium\t142.6 mg\n  Potassium\t907.9 mg\n  Total Carbohydrate\t41.6 g\n     Dietary Fiber\t2.5 g\n     Sugars\t45.7 g\n  Protein\t12.4 g\n  Vitamin A\t27.3 %\n  Vitamin B-12\t18.7 %\n  Vitamin B-6\t17.5 %\n  Vitamin C\t178.8 %\n  Vitamin D\t0.0 %\n  Vitamin E\t9.2 %\n  Calcium\t43.1 %\n  Copper\t11.5 %\n  Folate\t19.9 %\n  Iron\t2.6 %\n  Magnesium\t14.7 %\n  Manganese\t3.9 %\n  Niacin\t6.8 %\n  Pantothenic Acid\t17.2 %\n  Phosphorus\t32.0 %\n  Riboflavin\t32.6 %\n  Selenium\t11.5 %\n  Thiamin\t18.5 %\n  Zinc\t12.8 %\n\n*Percent Daily Values are based on a 2,000 calorie diet. Your daily values may be higher or lower depending on your calorie needs.','0' " + 
 				"UNION SELECT '28','Constipation Clearer', 'Orange Banana Yogurt','Drink this to help relieve constipation.','2 bananas \n1 orange \n1 cup of yogurt','  Calories\t397.2\n  Total Fat\t4.8 g\n     Saturated Fat\t2.8 g\n     Polyunsaturated Fat\t0.4 g\n     Monounsaturated Fat\t1.2 g\n  Cholesterol\t13.2 mg\n  Sodium\t156.3 mg\n  Potassium\t1,686.6 mg\n  Total Carbohydrate\t76.3 g\n     Dietary Fiber\t4.7 g\n     Sugars\t57.0 g\n  Protein\t15.1 g\n  Vitamin A\t11.4 %\n  Vitamin B-12\t20.5 %\n  Vitamin B-6\t77.5 %\n  Vitamin C\t155.0 %\n  Vitamin D\t0.0 %\n  Vitamin E\t5.3 %\n  Calcium\t46.9 %\n  Copper\t16.7 %\n  Folate\t26.9 %\n  Iron\t5.7 %\n  Magnesium\t29.9 %\n  Manganese\t20.2 %\n  Niacin\t9.4 %\n  Pantothenic Acid\t22.3 %\n  Phosphorus\t38.2 %\n  Riboflavin\t44.8 %\n  Selenium\t14.9 %\n  Thiamin\t21.0 %\n  Zinc\t16.3 %\n\n*Percent Daily Values are based on a 2,000 calorie diet. Your daily values may be higher or lower depending on your calorie needs.','0' " + 
 				"UNION SELECT '29','Wrinkle Waner', 'Orange Papaya Lemon Yogurt','This drink is loaded in vitamin C and A and can also help to reduce fine wrinkles.','2 oranges \n1 cup of papaya \n1 teaspoon of lemon juice \n3/4 cups of yogurt','  Calories\t269.1\n  Total Fat\t3.5 g\n     Saturated Fat\t2.0 g\n     Polyunsaturated Fat\t0.1 g\n     Monounsaturated Fat\t0.9 g\n  Cholesterol\t12.0 mg\n  Sodium\t142.7 mg\n  Potassium\t1,188.6 mg\n  Total Carbohydrate\t45.9 g\n     Dietary Fiber\t3.8 g\n     Sugars\t44.3 g\n  Protein\t13.6 g\n  Vitamin A\t29.6 %\n  Vitamin B-12\t18.7 %\n  Vitamin B-6\t14.5 %\n  Vitamin C\t344.8 %\n  Vitamin D\t0.0 %\n  Vitamin E\t7.9 %\n  Calcium\t49.2 %\n  Copper\t8.5 %\n  Folate\t33.7 %\n  Iron\t2.8 %\n  Magnesium\t17.6 %\n  Manganese\t4.4 %\n  Niacin\t6.3 %\n  Pantothenic Acid\t20.5 %\n  Phosphorus\t33.1 %\n  Riboflavin\t33.0 %\n  Selenium\t12.0 %\n  Thiamin\t23.3 %\n  Zinc\t13.5 %\n\n*Percent Daily Values are based on a 2,000 calorie diet. Your daily values may be higher or lower depending on your calorie needs.','0' " + 
 				"UNION SELECT '30','Dietary Digestion', 'Celery Pear Ginger','The pear acts as a gentle laxative and the ginger helps with good digestion.','3/4 cups of pear \n1/2 cups of celery \n1 inch of fresh ginger','  Calories\t546.0\n  Total Fat\t3.5 g\n   \t  Saturated Fat\t0.5 g\n   \t  Polyunsaturated Fat\t1.0 g\n   \t  Monounsaturated Fat\t0.5 g\n  Cholesterol\t0.0 mg\n  Sodium\t382.1 mg\n  Potassium\t3,057.8 mg\n  Total Carbohydrate\t133.0 g\n   \t  Dietary Fiber\t28.4 g\n   \t  Sugars\t41.9 g\n  Protein\t13.1 g\n  Vitamin A\t502.2 %\n  Vitamin B-12\t0.0 %\n  Vitamin B-6\t52.0 %\n  Vitamin C\t420.6 %\n  Vitamin D\t0.0 %\n  Vitamin E\t28.7 %\n  Calcium\t42.7 %\n  Copper\t56.4 %\n  Folate\t103.9 %\n  Iron\t35.5 %\n  Magnesium\t57.8 %\n  Manganese\t98.5 %\n  Niacin\t23.6 %\n  Pantothenic Acid    \t20.3 %\n  Phosphorus    \t26.9 %\n  Riboflavin\t38.7 %\n  Selenium\t11.7 %\n  Thiamin\t40.5 %\n  Zinc\t14.3 %\n\n*Percent Daily Values are based on a 2,000 calorie diet. Your daily values may be higher or lower depending on your calorie needs.','0' " + 
 				"UNION SELECT '31','Body Booster', 'Lemon Spinach Beetroot Celery Carrot Ginger Orange','Helps to lower blood pressure, improve digestion, boost your immune system, and helps you handle stress.','1/2 lemon \n4 oz of beetroot \n4 oz of celery \n4 oz of spinach \n4 oz of carrot\n 2 oranges \n 1 inch of ginger','  Calories\t303.0\n  Total Fat\t1.8 g\n   \t  Saturated Fat\t0.3 g\n   \t  Polyunsaturated Fat\t0.6 g\n   \t  Monounsaturated Fat\t0.2 g\n  Cholesterol\t0.0 mg\n  Sodium\t276.4 mg\n  Potassium\t2,159.5 mg\n  Total Carbohydrate\t67.9 g\n   \t  Dietary Fiber\t14.9 g\n   \t  Sugars\t41.0 g\n  Protein\t10.2 g\n  Vitamin A\t498.1 %\n  Vitamin B-12\t0.0 %\n  Vitamin B-6\t40.1 %\n  Vitamin C\t384.7 %\n  Vitamin D\t0.0 %\n  Vitamin E\t19.2 %\n  Calcium\t34.3 %\n  Copper\t32.8 %\n  Folate\t89.7 %\n  Iron\t27.3 %\n  Magnesium\t44.5 %\n  Manganese\t75.9 %\n  Niacin\t18.3 %\n  Pantothenic Acid    \t15.1 %\n  Phosphorus    \t19.1 %\n  Riboflavin\t28.2 %\n  Selenium\t5.8 %\n  Thiamin\t32.5 %\n  Zinc\t9.9 %\n\n*Percent Daily Values are based on a 2,000 calorie diet. Your daily values may be higher or lower depending on your calorie needs.','0' " + 
 				"UNION SELECT '32','Colossal Chlorophyll', 'Kale Spinach Orange Asparagus','This drink is loaded with chlorophyll and vitamins A, C, and E. It''s very good for your skin and gives you a good dose of nutrients.','4 kale leaves \n1/2 cup of spinach \n2 oranges \n5 stalks of asparagus','  Calories\t129.6\n  Total Fat\t1.3 g\n   \t  Saturated Fat\t0.1 g\n   \t  Polyunsaturated Fat\t0.5 g\n   \t  Monounsaturated Fat\t0.1 g\n  Cholesterol\t0.0 mg\n  Sodium\t58.3 mg\n  Potassium\t1,220.9 mg\n  Total Carbohydrate\t30.0 g\n   \t  Dietary Fiber\t5.2 g\n   \t  Sugars\t27.2 g\n  Protein\t8.4 g\n  Vitamin A\t579.4 %\n  Vitamin B-12\t0.0 %\n  Vitamin B-6\t28.0 %\n  Vitamin C\t390.2 %\n  Vitamin D\t0.0 %\n  Vitamin E\t20.7 %\n  Calcium\t27.7 %\n  Copper\t29.3 %\n  Folate\t58.9 %\n  Iron\t17.3 %\n  Magnesium\t21.9 %\n  Manganese\t61.2 %\n  Niacin\t13.7 %\n  Pantothenic Acid    \t9.0 %\n  Phosphorus    \t14.3 %\n  Riboflavin\t21.9 %\n  Selenium\t7.2 %\n  Thiamin\t30.3 %\n  Zinc\t7.3 %\n\n*Percent Daily Values are based on a 2,000 calorie diet. Your daily values may be higher or lower depending on your calorie needs.','0' " + 
 				"UNION SELECT '33','Eminent Endole', 'Lemon Kale Apple Cabbage Cauliflower Broccoli','This drink is full of endole, a cancer preventative chemical.','3 kale leaves \n1/2 lemon \n 2 apples \n2 stalks of broccoli \nhalf head of cabbage \nhalf head of cauliflower','  Calories\t430.1\n  Total Fat\t4.0 g\n   \t  Saturated Fat\t0.7 g\n   \t  Polyunsaturated Fat\t1.9 g\n   \t  Monounsaturated Fat\t0.2 g\n  Cholesterol\t0.0 mg\n  Sodium\t281.0 mg\n  Potassium\t3,661.7 mg\n  Total Carbohydrate\t100.0 g\n   \t  Dietary Fiber\t39.3 g\n   \t  Sugars\t25.2 g\n  Protein\t24.8 g\n  Vitamin A\t463.6 %\n  Vitamin B-12\t0.0 %\n  Vitamin B-6\t96.3 %\n  Vitamin C\t1,119.5 %\n  Vitamin D\t0.0 %\n  Vitamin E\t37.8 %\n  Calcium\t56.8 %\n  Copper\t41.0 %\n  Folate\t149.6 %\n  Iron\t48.1 %\n  Magnesium\t57.7 %\n  Manganese\t126.3 %\n  Niacin\t28.9 %\n  Pantothenic Acid    \t44.9 %\n  Phosphorus    \t49.5 %\n  Riboflavin\t51.4 %\n  Selenium\t24.0 %\n  Thiamin\t48.7 %\n  Zinc\t22.0 %\n\n*Percent Daily Values are based on a 2,000 calorie diet. Your daily values may be higher or lower depending on your calorie needs.','0' " + 
 				"UNION SELECT '34','Cold Calmer', 'Apple lemon Ginger','A healthy drink that can help cure colds.','2 apples \n1 lemon \n1 inch of ginger','Calories \t189.4\n  Total Fat \t0.8 g\n    \t  Saturated Fat \t0.3 g\n    \t  Polyunsaturated Fat \t0.3 g\n    \t  Monounsaturated Fat \t0.0 g\n  Cholesterol \t0.0 mg\n  Sodium \t4.0 mg\n  Potassium \t499.0 mg\n  Total Carbohydrate \t44.8 g\n    \t  Dietary Fiber \t6.7 g\n    \t  Sugars \t27.7 g\n  Protein \t1.8 g\n  Vitamin A \t3.5 %\n  Vitamin B-12 \t0.0 %\n  Vitamin B-6 \t13.0 %\n  Vitamin C \t165.4 %\n  Vitamin D \t0.0 %\n  Vitamin E \t4.5 %\n  Calcium \t8.7 %\n  Copper \t20.5 %\n  Folate \t2.2 %\n  Iron \t7.3 %\n  Magnesium \t7.4 %\n  Manganese \t6.9 %\n  Niacin \t2.4 %\n  Pantothenic Acid     \t4.4 %\n  Phosphorus     \t3.8 %\n  Riboflavin \t4.9 %\n  Selenium \t1.2 %\n  Thiamin \t6.8 %\n  Zinc \t1.5 %\n\n*Percent Daily Values are based on a 2,000 calorie diet. Your daily values may be higher or lower depending on your calorie needs.','0' " + 
 				"UNION SELECT '35','Go Green', 'Apple Grape Lemon','A delicious and healthy drink with a great color.','3 granny smith apples \n1 cup green seedless grapes \n1 wedge of lemon','Calories \t493.4\n  Total Fat \t4.7 g\n    \t  Saturated Fat \t0.6 g\n    \t  Polyunsaturated Fat \t0.6 g\n    \t  Monounsaturated Fat \t0.0 g\n  Cholesterol \t0.0 mg\n  Sodium \t7.5 mg\n  Potassium \t689.5 mg\n  Total Carbohydrate \t117.9 g\n    \t  Dietary Fiber \t20.0 g\n    \t  Sugars \t93.7 g\n  Protein \t2.5 g\n  Vitamin A \t5.9 %\n  Vitamin B-12 \t0.0 %\n  Vitamin B-6 \t22.3 %\n  Vitamin C \t225.0 %\n  Vitamin D \t0.0 %\n  Vitamin E \t10.1 %\n  Calcium \t11.1 %\n  Copper \t29.0 %\n  Folate \t3.8 %\n  Iron \t10.0 %\n  Magnesium \t10.1 %\n  Manganese \t11.5 %\n  Niacin \t4.9 %\n  Pantothenic Acid     \t5.0 %\n  Phosphorus     \t6.1 %\n  Riboflavin \t10.5 %\n  Selenium \t1.7 %\n  Thiamin \t17.0 %\n  Zinc \t2.1 %\n\n*Percent Daily Values are based on a 2,000 calorie diet. Your daily values may be higher or lower depending on your calorie needs.','0' " + 
 				"UNION SELECT '36','Zesty Zing', 'Apple cucumber ginger','A drink with a zing that will help wake you up in the morning.','2 1/2 apples \n1/2 cucumber \n1 inch of ginger','Calories \t231.3\n  Total Fat \t0.8 g\n    \t  Saturated Fat \t0.3 g\n    \t  Polyunsaturated Fat \t0.4 g\n    \t  Monounsaturated Fat \t0.0 g\n  Cholesterol \t0.0 mg\n  Sodium \t4.3 mg\n  Potassium \t655.1 mg\n  Total Carbohydrate \t48.6 g\n    \t  Dietary Fiber \t6.8 g\n    \t  Sugars \t34.7 g\n  Protein \t1.8 g\n  Vitamin A \t10.1 %\n  Vitamin B-12 \t0.0 %\n  Vitamin B-6 \t12.2 %\n  Vitamin C \t47.0 %\n  Vitamin D \t0.0 %\n  Vitamin E \t6.2 %\n  Calcium \t4.8 %\n  Copper \t10.9 %\n  Folate \t7.7 %\n  Iron \t6.1 %\n  Magnesium \t9.6 %\n  Manganese \t14.6 %\n  Niacin \t3.4 %\n  Pantothenic Acid     \t5.1 %\n  Phosphorus     \t5.8 %\n  Riboflavin \t5.0 %\n  Selenium \t1.5 %\n  Thiamin \t6.5 %\n  Zinc \t3.1 %\n\n*Percent Daily Values are based on a 2,000 calorie diet. Your daily values may be higher or lower depending on your calorie needs.','0' " + 
 				"UNION SELECT '37','Super Slim', 'Celery Carrots Spinach Parsley Cayenne Pepper','All the greens will help you lose weight and the cayenne pepper will give it some flavor.','1 stalk of celery \n5 carrots \n1/2 cups of spinach \n1/2 cups of parsley \n1 teaspoon of cayenne pepper (optional)','Calories \t175.4\n  Total Fat \t1.4 g\n    \t  Saturated Fat \t0.2 g\n    \t  Polyunsaturated Fat \t0.5 g\n    \t  Monounsaturated Fat \t0.2 g\n  Cholesterol \t0.0 mg\n  Sodium \t326.2 mg\n  Potassium \t1,641.7 mg\n  Total Carbohydrate \t30.6 g\n    \t  Dietary Fiber \t7.7 g\n    \t  Sugars \t16.8 g\n  Protein \t5.6 g\n  Vitamin A \t985.7 %\n  Vitamin B-12 \t0.0 %\n  Vitamin B-6 \t30.8 %\n  Vitamin C \t150.4 %\n  Vitamin D \t0.0 %\n  Vitamin E \t15.1 %\n  Calcium \t21.9 %\n  Copper \t13.6 %\n  Folate \t47.9 %\n  Iron \t25.8 %\n  Magnesium \t22.0 %\n  Manganese \t41.5 %\n  Niacin \t22.1 %\n  Pantothenic Acid     \t12.5 %\n  Phosphorus     \t17.3 %\n  Riboflavin \t18.4 %\n  Selenium \t1.4 %\n  Thiamin \t20.8 %\n  Zinc \t10.1 %\n\n*Percent Daily Values are based on a 2,000 calorie diet. Your daily values may be higher or lower depending on your calorie needs.','0' " + 				
 				"UNION SELECT '38','Wondrous Watermelon', 'Watermelon Cantaloupe Ginger','This drink has a wonderful flavor even without the ginger.','2 cups cubed watermelon \n2 cups cubed cantaloupe \n1 inch of ginger','Calories \t217.4\n  Total Fat \t2.4 g\n    \t  Saturated Fat \t0.4 g\n    \t  Polyunsaturated Fat \t0.8 g\n    \t  Monounsaturated Fat \t0.4 g\n  Cholesterol \t0.0 mg\n  Sodium \t36.3 mg\n  Potassium \t1,382.9 mg\n  Total Carbohydrate \t40.5 g\n    \t  Dietary Fiber \t2.4 g\n    \t  Sugars \t20.2 g\n  Protein \t5.0 g\n  Vitamin A \t228.7 %\n  Vitamin B-12 \t0.0 %\n  Vitamin B-6 \t40.9 %\n  Vitamin C \t274.5 %\n  Vitamin D \t0.0 %\n  Vitamin E \t4.7 %\n  Calcium \t6.1 %\n  Copper \t12.7 %\n  Folate \t15.5 %\n  Iron \t7.1 %\n  Magnesium \t18.1 %\n  Manganese \t14.1 %\n  Niacin \t12.6 %\n  Pantothenic Acid     \t10.9 %\n  Phosphorus     \t8.6 %\n  Riboflavin \t7.7 %\n  Selenium \t2.3 %\n  Thiamin \t24.1 %\n  Zinc \t5.0 %\n\n*Percent Daily Values are based on a 2,000 calorie diet. Your daily values may be higher or lower depending on your calorie needs.','0' " + 
 				"UNION SELECT '39','Papaya Passion', 'Papaya Date Apple','This drink will stimulate your metabolism. Add spices like allspice or cinnamon for added effect.','1 papaya \n5 pitted dates \n1 apple','Calories \t317.1\n  Total Fat \t0.8 g\n    \t  Saturated Fat \t0.3 g\n    \t  Polyunsaturated Fat \t0.2 g\n    \t  Monounsaturated Fat \t0.1 g\n  Cholesterol \t0.0 mg\n  Sodium \t10.0 mg\n  Potassium \t1,212.3 mg\n  Total Carbohydrate \t72.0 g\n    \t  Dietary Fiber \t7.5 g\n    \t  Sugars \t58.0 g\n  Protein \t3.1 g\n  Vitamin A \t68.0 %\n  Vitamin B-12 \t0.0 %\n  Vitamin B-6 \t9.6 %\n  Vitamin C \t326.5 %\n  Vitamin D \t0.0 %\n  Vitamin E \t19.4 %\n  Calcium \t9.9 %\n  Copper \t9.6 %\n  Folate \t31.8 %\n  Iron \t5.5 %\n  Magnesium \t13.8 %\n  Manganese \t10.2 %\n  Niacin \t8.3 %\n  Pantothenic Acid     \t10.0 %\n  Phosphorus     \t5.1 %\n  Riboflavin \t8.5 %\n  Selenium \t4.9 %\n  Thiamin \t8.5 %\n  Zinc \t2.6 %\n\n*Percent Daily Values are based on a 2,000 calorie diet. Your daily values may be higher or lower depending on your calorie needs.','0'");
 		
	/*
	 * 
	 
 				 
	 */


    	
    }
    
}